Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Geometric
1) Alter table to add SPATIAL INDEX
2) Assembling of the MULTIPOINT string
3) Bounding Box Functions
4) Calculate the area
5) Calculates the actual distances and excludes the cities that are too far away
6) Calculation of the length of a route
7) Cariable @mp is assigned a Multipoint object with three points
8) Collect several geometric columns of a table into a GEOMETRYCOLLECTION
9) Determine the length of the outer polygon with EXTERIORRING function
10) Find the most westerly and easterly points
11) Functions for All Geometric Objects in MySQL
12) Functions for Converting MySQL Geometric Data
13) Functions for Point Objects
14) Geometric Functions for GeometryCollection Objects
15) Geometric Functions for Line Objects
16) Geometric Functions for Polygon Objects
17) Geometric Functions List
18) Geometric Types in MySQL That Store Exactly One Object
19) Geometric Types in MySQL That Store Several Objects in a Single Cell
20) Get the bounding box of each geometric object
21) Get the Total length
22) In calculating areas (AREA), all holes in a polygon are subtracted out
23) Indexing Geometric Data
24) Length of a LineString is sought
25) POINT type column
26) Point type column with default value
27) POLYGON type column
28) Query the length of the lines
29) Querying geometric data is with the asText function
30) Search for a certain distance
31) That the two geometric objects touch is shown by the TOUCHES function
32) The ASTEXT function specifies the bounding box in WKT format
33) To specify the start and terminal points in Well-Known Text format, a simple SELECT query will suffice
34) Total area with POLYGON
35) Use ASTEXT with point value
36) Use X(), Y() functions with point type
37) Using GEOMFROMTEXT function
38) Using the POLYGON object in the variable